Prisma Client

PrismaのORM部分のこと

TypeScriptでqueryを書く

「clitnt」というのはDBに対するclientのこと

だから普通はserver側に書く

docsよみ

Working with PrismaClient

Generating the client

Using custom model and field names

Connecting and disconnecting

Connection pool

Configuring logging

Configuring error formatting

CRUD

もうちょい書いた後に再読したい

Select fields

Relation queries

Filtering and sorting

sorting

Working with fields

Working with Json fields

Working with scalar lists

Advanced type safety

Operating against partial structures of your model types

Prisma validator

Middleware

Middleware sample: soft delete

Middleware sample: logging

Middleware sample: session data

Pagination

Aggregation, grouping, and summarizing

Composite types

Full-text searchPreview

Custom validation

Computed fields

Excluding fields

Custom models

Case sensitivity

Null and undefined

Debugging

Module bundlers

Database polyfills

Handling exceptions and errors

MetricsPreview

OpenTelemetry tracingPreview

Prisma Client extensionsPreview

Add custom methods to your models

Add methods to Prisma Client

Create custom Prisma Client queries

Add custom fields and methods to query results

Shared Prisma Client extensions

api reference

Remarks

datasources

log

errorFormat

rejectOnNotFound

Remarks

Model query options

select

include

where

orderBy

distinct

Nested queries

create

createMany

set

connect

disconnect

update

upsert

delete

updateMany

deleteMany

Scalar list methods

Reference

set

push

unset

Scalar list filters

Remarks

Reference

has

hasEvery

hasSome

isEmpty

isSet

equals

Composite type methods

set

unset

update

upsert

push

Composite type filters

Reference

equals

is

isNot

isEmpty

every

some

none

Atomic number operations

Operators

Reference

Remarks

Examples

JSON filters

Remarks

path

string_contains

string_starts_with

string_ends_with

array_contains

array_starts_with

array_ends_with

Client methods

$disconnect()

$connect()

$on()

$use()

$executeRaw()

$queryRaw()

$runCommandRaw()

$metrics

$extends

Utility types

Prisma.validator

Compare columns in the same table

Considerations

Filter on non-unique fields with UserWhereUniqueInput

Enable the ability to filter on non-unique fields with UserWhereUniqueInput

Optimistic concurrency control on updates

Permission checks

Soft deletes

UserWhereUniqueInput considerations